UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0XBn1QLd3t9SGPUWCWQ4Zo/1E+X+CubZwZs6Q4EtKZc='
WHERE
key_id = 'a6cc166ce39ee2e5ce9d390cf0bcc9255f0b7d9dbfd6a9f020775743f5d70c3c'
AND (
token = '0XBn1QLd3t9SGPUWCWQ4Zo/1E+X+CubZwZs6Q4EtKZc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)