UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RtA1JiUGwprrabGtkoxTiehOXYhtaSgjMf+pAdUNX3U='
WHERE
key_id = '12d96aa1fa1ec382fa69d8efe84603afeef3a2034ec9eabe02e7077548a7ad31'
AND (
token = 'RtA1JiUGwprrabGtkoxTiehOXYhtaSgjMf+pAdUNX3U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)