UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bgw9mJugi2gwRjpmvnaBAXZj8vHJF19ROP3MKGorGas='
WHERE
key_id = '54ac94b1e462ef2890e6d734ca850543e7f70e63c94e5b94902b886480bf2cf1'
AND (
token = 'Bgw9mJugi2gwRjpmvnaBAXZj8vHJF19ROP3MKGorGas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)