UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2/6bMhsdT072euISK79JyvPCSP/Qyxvl1CwSYjVyoK0='
WHERE
key_id = 'f48779bd5e46040cd06acdacd48d46423c4d508f6ffd269ff5726963958ca47b'
AND (
token = '2/6bMhsdT072euISK79JyvPCSP/Qyxvl1CwSYjVyoK0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)