UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A75zUBSISby4lHxJBUwXVYS22t4PousqbX3w2UxpRnE='
WHERE
key_id = '16e0ed47c3e0a4b934b6e0db10036d60ad1941a8d8e69d6a769882dc1c36be65'
AND (
token = 'A75zUBSISby4lHxJBUwXVYS22t4PousqbX3w2UxpRnE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)