UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3COgHRhaKVvfF1DLAECvjPMAjvfmVCFFOOGXLtmZzVc='
WHERE
key_id = 'de9e0f692ef03f842c7116fd8f0dbc52e94d88ae3ab6de3d7031081d24e5e7cf'
AND (
token = '3COgHRhaKVvfF1DLAECvjPMAjvfmVCFFOOGXLtmZzVc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)