UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J4n65drYq7pqzFd3aVITKZXcNQBnHo/lpF7pkajnswg='
WHERE
key_id = '8a0e1dd4ad732265cca362fa2b5a0bbf654b32471f726977a80fcacd5795ac80'
AND (
token = 'J4n65drYq7pqzFd3aVITKZXcNQBnHo/lpF7pkajnswg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)