UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8gkic/phdk26Z75hr1g0P+n06ioHauTjYBzuvI/Pm1s='
WHERE
key_id = '6a33d111b6e1accb1641179364b731ca2a688fc15531d84f79272c958e5c7970'
AND (
token = '8gkic/phdk26Z75hr1g0P+n06ioHauTjYBzuvI/Pm1s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)