UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hk+cTshEecF1/vOcKYevt2RDaliOMLqF7H/sw8hI5qE='
WHERE
key_id = 'c6164aad6d7bf30ca125b7ba7015c7f78f953e91fd2ddcabd4d3ec3f8b44c999'
AND (
token = 'Hk+cTshEecF1/vOcKYevt2RDaliOMLqF7H/sw8hI5qE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)