UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2ldaw1txL23WXesgL3gf/AzZYcEOcINNCe73np0/AAY='
WHERE
key_id = '9ed20158edc2ff398826dd8ae6bba20dfe9434fffad85685142724a92b52d34e'
AND (
token = '2ldaw1txL23WXesgL3gf/AzZYcEOcINNCe73np0/AAY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)