UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U8oYs1YksZaFe8aro4gKviD1aVn60zI6CnQnb1LQc/w='
WHERE
key_id = 'f16958c4e956556defa7bf252e627d8647dc067f2eb1795d1e7f59174e6a33b3'
AND (
token = 'U8oYs1YksZaFe8aro4gKviD1aVn60zI6CnQnb1LQc/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)