UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yiM5yjZ/06YSvKwWx0awUyLtfbTq9QUwIJLWUovOOjM='
WHERE
key_id = 'f20a0c4a529af54ed45d81ab83eb7ee35863f795b27a54865e82544c674b27c3'
AND (
token = 'yiM5yjZ/06YSvKwWx0awUyLtfbTq9QUwIJLWUovOOjM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)