UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CKZipCGEtMP3x/dOEVcui+xSl3KL4X7yWRaTrYfb5VA='
WHERE
key_id = 'a0ab9302539891bbdbcd2ab111216d4c60841a44382b5b02c5d150fe505e8ddf'
AND (
token = 'CKZipCGEtMP3x/dOEVcui+xSl3KL4X7yWRaTrYfb5VA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)