UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VmlNBpQ9TJUVrswTHkTNQYQhxVWuw5kkwgSYj8Wdp78='
WHERE
key_id = 'a7786a44c3456b05733d3ae246acb8093612a72b30796a65c4a731d4db74246c'
AND (
token = 'VmlNBpQ9TJUVrswTHkTNQYQhxVWuw5kkwgSYj8Wdp78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)