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