UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6kxm9rfGi3x0RsuGChNajQlZsYDd4k+lrenC/c32aqE='
WHERE
key_id = '8f37f4bcb50fcf35cbdb3724cd72f284ac7e62edb7cbd95ca79139e24406b25b'
AND (
token = '6kxm9rfGi3x0RsuGChNajQlZsYDd4k+lrenC/c32aqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)