UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N1tDsDJWdq9Z0+XxrtsUEeutv+Nur4I3o1XZ79Zxqa0='
WHERE
key_id = '5a2dee6a4fdf42d016fc781a74d415fd56a9c6443f0c891af3d190fc1208796a'
AND (
token = 'N1tDsDJWdq9Z0+XxrtsUEeutv+Nur4I3o1XZ79Zxqa0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)