UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm0zuZV0avCO8yklj7khCHaFwK/0imGrAs17+Hi3iTCg='
WHERE
key_id = 'c3d8cfa1ab4d41f23ae6dc1bd81c1a9c26d3dfb227239bbb0aeb6daf3a02ff7e'
AND (
token = 'm0zuZV0avCO8yklj7khCHaFwK/0imGrAs17+Hi3iTCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)