UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nvpoKm+iwVnX/eDApCYJm+cYY/uWvoISl+U50aarB+A='
WHERE
key_id = '697c5e042cf781978a1787a5859ef7ac2c5fd50845f99d1c8094cdd2e623df1a'
AND (
token = 'nvpoKm+iwVnX/eDApCYJm+cYY/uWvoISl+U50aarB+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)