UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NKE+xjyQEhmyVCjxai9UimtWN8tKpwisSMNsL1qTs00='
WHERE
key_id = 'bf322f495c3886e6e0164b65909f336c078d026b6382afa0ec44edee8a1e5b19'
AND (
token = 'NKE+xjyQEhmyVCjxai9UimtWN8tKpwisSMNsL1qTs00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)