UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tXnMvWZDmoiA3fpCuUT6D3b7rK47miWQCZK2/0ZCyzo='
WHERE
key_id = 'b3450fb4f83d7e532e17cfb46a7864407ef9f209eab2b099606372c304cad264'
AND (
token = 'tXnMvWZDmoiA3fpCuUT6D3b7rK47miWQCZK2/0ZCyzo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)