UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hhW4qJlfquJpuBiv0amm3/pUcoagiybdVV5ajlOqwek='
WHERE
key_id = '80ae73c52e98d86b084d263c2d2821cd131ef76fbc748288caddd46c38123dec'
AND (
token = 'hhW4qJlfquJpuBiv0amm3/pUcoagiybdVV5ajlOqwek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)