UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jVDcrsgdV3f8n67druLgsAzWGFsHaNlfD8Z2s5vjSBA='
WHERE
key_id = 'd2e44439773fadd3297a749cf53fa5d137c97fc9ff6c635876131db53742a6e6'
AND (
token = 'jVDcrsgdV3f8n67druLgsAzWGFsHaNlfD8Z2s5vjSBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)