UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xv74+etVlte/SaSqogXZ/nznEoDZ5aA9j+9dUuzr8ac='
WHERE
key_id = '48faa91b0c8afff388479875d3c41418c3f98d98d11d84fd6f178bc5e389de41'
AND (
token = 'xv74+etVlte/SaSqogXZ/nznEoDZ5aA9j+9dUuzr8ac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)