UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'boUTGJ4NT3gfcTgJ5I4+Tqobh+frSH7BdIUPTkv8cds='
WHERE
key_id = '06e1050ed7315213bf97dd28764ed63ab7fb9f63bebb8fb121a77511c5ec4841'
AND (
token = 'boUTGJ4NT3gfcTgJ5I4+Tqobh+frSH7BdIUPTkv8cds='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)