UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kBOBN7/o78KuQOFAjm7WJ70czHvGoP9CHD1EhAdVqxw='
WHERE
key_id = '28327bfe9b5b611646ab5d16f9f2ea6fcbd1d4ef1094d6e5172a1dd45b023ec6'
AND (
token = 'kBOBN7/o78KuQOFAjm7WJ70czHvGoP9CHD1EhAdVqxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)