UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wJ8ZskOIJ3U35/VluH9dkQAGs/UEQnttucN0sKM+ZF8='
WHERE
key_id = 'def5d90dbda89cde19bd54078fbe39b053aedbd7ae47353db4ca7ac227db420a'
AND (
token = 'wJ8ZskOIJ3U35/VluH9dkQAGs/UEQnttucN0sKM+ZF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)