UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YI4MQ/wzFsIdmGDYM9If2/oH8j/ec+yxhiK/3FXi+jc='
WHERE
key_id = '0f23f38e45c495263c0e11938fa2427c3904bfa4c351e240ac9d58690681291d'
AND (
token = 'YI4MQ/wzFsIdmGDYM9If2/oH8j/ec+yxhiK/3FXi+jc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)