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