UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XJseEVmV2wgYzbC8fbuPCGsL5HtgVBxPqtVZMgmQTto='
WHERE
key_id = '0bae9711ee44ce7e16c76dd8a4156d918cb4eb93a529ff91f4dcbeafa7fba43d'
AND (
token = 'XJseEVmV2wgYzbC8fbuPCGsL5HtgVBxPqtVZMgmQTto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)