UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YsJBLEh7xRdzuNFjwX4MYTzYHZjcmV+4qn54HbxZ5JM='
WHERE
key_id = 'b19b8bd796a2b2938c20dfe28f8894e3091631d59864ab5eb6e320e58d4a8966'
AND (
token = 'YsJBLEh7xRdzuNFjwX4MYTzYHZjcmV+4qn54HbxZ5JM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)