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