UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QEjw74chVAh0Mvtbg782EY5dFSJ0LQ8OURZGkB4r6Tk='
WHERE
key_id = '6e92e2eefc512dfda500ab776eab03be0b7807fe3ca84aa5d9b0cad0ee28ac19'
AND (
token = 'QEjw74chVAh0Mvtbg782EY5dFSJ0LQ8OURZGkB4r6Tk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)